Install PAM modules and systemd units into /usr

Since Debian trixie all files need to be installed into their canonical
location under /usr.

Origin: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1061348
Forwarded: https://github.com/MariaDB/server/pull/4065

Gbp-Pq: Name install-files-into-usr.patch

cmake: add support for reproducible buildS

We should use relative path not absolute path. We can use target without
breaking reproducibility.

This patch can be removed once MariaDB ships with Mroonga v12.00+ that has
https://github.com/mroonga/mroonga/commit/27caeb9b8ce7fa432b1251eca475b517c6902a6c

Origin: https://github.com/mroonga/mroonga/issues/298#issuecomment-1030815927
Bug: https://github.com/mroonga/mroonga/issues/298
Forwarded: not-needed

Gbp-Pq: Name mroonga-mrn-lib-dirs-path-reproducible-build.patch

Fix perl path in scripts

Fix Lintian issue https://lintian.debian.org/tags/incorrect-path-for-interpreter.html

Upstream will never accept this patch,
see https://github.com/MariaDB/server/pull/1718

Origin: https://patch-diff.githubusercontent.com/raw/MariaDB/server/pull/1718.patch
Forwarded: https://github.com/MariaDB/server/pull/1718 (rejected, will never be merged)

Gbp-Pq: Name env-perl-usr-bin-perl.patch

mariadb (1:11.8.6-5) unstable; urgency=medium

  * New mariadb-server installs will now use /var/lib/mariadb as the default
    data directory. See NEWS for details.
    - Determine whether to use /var/lib/mysql or /var/lib/mariadb during
      mariadb-server preinst and postinst.
    - On purge, remove /var/lib/mariadb, and /var/lib/mysql only if owned by
      mariadb.
    - d/p/set-default-datadir-to-var-lib-mariadb.patch: Update compile-time
      INSTALL_MYSQLDATADIR_DEB setting to /var/lib/mariadb.
    - d/mariadb-server.mariadb.init: Default to /var/lib/mariadb if datadir is
      not specified in config.
    - d/additions/50-server.cnf: Update default datadir in comment to
      /var/lib/mariadb.
    - Update autopkgtests to match new data directory expectations.
    - Apport: Include /var/lib/mariadb data directory info in report.
    - Salsa CI: Confirm correct datadir is in use for each test and add list of
      /var/lib/mariadb files as test artifact.
  * Use mariadb_upgrade_info/mysql_upgrade_info version files instead of
    generated flag files to detect active data directory and downgrade
    attempts.

[dgit import unpatched mariadb 1:11.8.6-5]

Import mariadb_11.8.6-5.debian.tar.xz

[dgit import tarball mariadb 1:11.8.6-5 mariadb_11.8.6-5.debian.tar.xz]

Import mariadb_11.8.6.orig.tar.gz

[dgit import orig mariadb_11.8.6.orig.tar.gz]